IMG
Loading..
Select a color
Boys Short Sleeve Oxford Shirt
Item: 8FT-SE9003
Brand: French Toast

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
    1. Cotton-blend oxford
    2. Mechanical stretch fabric
    3. Wrinkle No More fabric for easy care
    4. Expandable shirt collar
    5. Pearlized button closure
    6. Chest pocket
    7. Back pleat for easy movement
    8. Machine washable
 
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = '8FT-SE9003') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`